SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023307 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023307 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123684,605533,278565,808094,366940,115294,946025,141927,376156,357461,955559,916281,345832,703735,429155,399894,839594,755991,4497,68550,74537,213817,26186,551065,873061,276399,194957,471781,704231,588061,36420,252519,1027134,799505,470370,741478,334805,210806,198773,743176,101381,620639,424737,448434,676070,103575,119187,237139,656734,141445,698738,733809,504723,859928,254921,544001,607967,262210,52841,105896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]