SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560937 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560937 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793243,663188,383772,435971,835133,1048081,223047,42004,862722,14745,996449,747633,778578,538067,376305,61263,509609,200132,160111,648783,446168,204924,937740,183109,694062,923096,906239,1003092,1033234,740415,940864,2367,666391,26092,791179,150748,818096,184512,791154,181361,349676,205102,81962,456213,713230,152749,70458,927818,979001,968813,264752,989676,774672,307312,361517,655718,460524,903004,571448,285638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]