SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591710 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591710 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046972,263351,646701,931394,646232,923299,981213,1004890,224203,978004,894779,134142,732933,865659,477303,576902,422760,169110,79890,400430,225052,269327,752685,1001121,784378,1037811,118559,481350,830774,313876,555389,16136,406449,509383,311734,400970,933938,774815,275965,920534,187046,464881,273365,660403,761371,784159,633867,984870,131690,623976,374553,683388,472240,197860,725660,773954,195205,136169,906481,108146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]