SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317311 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317311 [ RunTime:0.001372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155717,185557,734413,211017,753272,758142,563495,108275,1027320,5912,407362,933100,302941,657450,350749,1037875,256630,413526,791125,941403,4630,766379,500590,214944,737916,1018368,135569,953832,264361,940584,167868,276842,1009134,178634,874430,513270,7167,321144,652015,1007104,292019,217882,446102,603612,697971,109194,743539,522441,681747,471758,613290,929055,52282,1033251,840447,230110,552763,776062,66579,785775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]