SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540043 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540043 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279892,986038,701900,290047,355418,647184,72571,475189,618019,228927,743597,955482,665471,709370,926796,491313,1010635,184982,215593,737825,168890,681765,1013703,291328,395177,833246,698785,263161,726025,259022,181482,251973,479762,567840,1032160,704893,280218,546992,644029,627999,853970,308413,699078,259665,780781,155606,1021714,679488,580498,279959,936418,1018914,701491,519664,571094,820995,258619,927069,856810,89094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]