SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407069 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407069 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866331,616082,200029,805799,541801,601164,163933,822346,757504,69641,42426,829739,440564,1040605,293260,450305,372742,14610,1018837,678001,56813,327841,681542,802439,733036,739908,207296,1027167,440776,118150,461400,25033,751682,812978,534412,982633,560921,788774,48574,112821,446750,652451,1046347,71528,381503,797157,834841,111383,1019261,451551,351324,368295,752612,55284,1013432,574827,876956,314300,38226,278058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]