SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566022 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566022 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889780,868784,222612,657162,1012024,85132,810667,780967,575227,181171,1045855,97114,231896,268645,989756,317771,871809,542255,411914,827688,216163,128302,283140,257623,622926,1037192,368942,734621,791017,826500,501744,701405,68448,592789,131703,5826,1025448,951632,734797,30079,162827,152834,518068,778926,465067,125160,174262,708168,919578,172492,240227,471177,899009,1019547,210632,270186,510509,926648,931764,187212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]