SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543958 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543958 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259468,976575,713913,588921,766546,630019,821663,211003,367542,422260,515510,834841,574038,277026,1020909,1004760,523869,417204,504607,197659,845180,974357,845763,964893,3553,751516,200085,326547,1012432,258848,176339,1034165,414543,483017,397422,1048821,977391,341336,85551,142891,187370,546689,213364,63206,282047,105152,819429,344181,459297,1014903,916017,712227,480122,251075,136372,169434,96293,821591,17563,615484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006840s ]