SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579509 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579509 [ RunTime:0.003970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800931,415910,667937,293660,88240,620143,487279,798360,4362,224587,986352,321730,42380,1033541,648892,521855,356296,338919,1030657,854833,541437,754397,408769,955677,731968,521215,219416,785269,427688,236147,840763,233807,474070,652286,268570,737627,689632,460808,806724,465879,308672,64859,886561,266392,724785,835938,642878,121443,742042,890788,1005751,560213,490824,926210,704327,800978,680035,346837,882776,461691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]