SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287510 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287510 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538843,9855,488448,21600,956249,1033350,267901,56752,778244,968070,348685,1037667,287842,538968,816121,38077,30135,940753,420162,799998,411448,590302,467143,558326,126016,742952,815190,925114,1033811,798493,869746,699901,246947,490644,979544,1028958,782176,617408,524603,506825,292634,501464,1047911,769844,19448,745432,559497,400094,666043,460199,368662,633044,870792,200277,683505,321030,46680,874953,284386,995548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]