SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029727 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029727 [ RunTime:0.003369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839676,447685,433201,508759,101623,207078,784575,430518,506539,892404,690931,117789,153065,30094,404455,360988,109385,629089,496915,951404,23418,126156,1719,900414,997469,570517,65066,8980,216026,852020,1033711,300321,199796,103150,1008695,530508,105614,906398,76702,744397,790494,244820,103179,840638,880052,177717,19045,538989,898671,381812,678447,603733,363129,97241,449754,73614,959879,249948,131849,445600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000870s ]