SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643042 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643042 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496582,258429,535825,436331,872024,204920,766700,368138,243669,197874,304771,386965,185084,490241,1023593,784472,726410,84153,1014845,273672,757462,20508,28534,332372,62580,75805,746066,44711,704674,291057,726927,217999,523576,208938,42825,736276,974,564684,144793,22529,665220,633494,851354,301070,311543,726610,991059,100213,437621,641547,870155,400389,399627,998534,142814,703304,633192,262304,18214,769950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]