SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008506 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008506 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400581,773483,1018009,176342,696064,245633,534675,508404,604946,475537,168328,588423,511676,614605,930693,648562,370348,141339,719362,445113,787771,154731,701378,753484,785111,645114,62382,817281,484875,696863,402650,677730,510925,753163,539771,484873,288664,396060,292494,125625,1011331,106201,710600,379922,959335,56880,122580,196592,1011235,507120,164627,10188,901978,869994,249531,373988,101697,840475,30488,239602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000949s ]