SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560800 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560800 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643115,429696,199229,896876,485125,577802,384562,696987,153719,151010,218313,116699,602817,819544,680845,233387,695183,652271,174586,289187,638228,110315,510850,67650,884222,103105,443746,470772,950640,1026540,24675,560958,69244,328996,484805,472003,200765,326948,958778,372508,1025064,44730,1032295,200780,979980,610760,598425,68739,518159,794892,672952,805689,727538,763752,891229,140892,858647,702663,797518,23010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]