SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50100 LIMIT 1 [ RunTime:0.000873s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50100 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997962,812115,113998,955480,903312,906715,747547,696392,251579,739450,997759,181419,960261,648345,558299,616082,655486,519927,319879,200634,209624,888539,782123,624547,400019,306009,307565,596644,245278,420505,415618,1019997,930629,259124,707696,306438,471395,47360,802208,117018,226395,990622,286074,135987,290381,680602,652193,907323,327760,235173,770871,528933,387497,763205,452034,538293,946424,357688,675078,329167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]