SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487516 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487516 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924101,580093,368362,248716,9890,173883,269772,3042,557697,354153,293844,182259,260655,1740,63330,961111,472757,250979,223952,376355,149746,996055,765245,78811,731473,820787,866616,398353,64720,285353,504954,351320,287793,159994,416160,604928,6328,126746,473028,603727,833316,182490,1000143,553289,385432,581983,342857,705788,999659,365197,271236,632074,932234,117284,640570,11853,191266,834865,852143,45961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]