SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003698s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040055 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040055 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591423,796488,189447,732442,948957,846011,646623,659266,4602,335327,735458,906784,673162,743674,827149,374607,368825,136971,892980,584189,108531,689856,491218,27056,565630,88456,287017,656248,800221,247570,1038416,86398,295031,729606,654169,1047785,667336,780262,840240,883657,669828,228271,331358,9560,587135,435418,63460,168059,381251,758934,617958,947669,861084,187560,821528,148062,856196,522247,826115,474751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001037s ]