SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442493 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442493 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562287,901805,1000459,823036,664097,629201,359190,974893,169125,414158,579234,325176,734136,291545,38891,281607,55991,392063,533163,104966,76435,227891,804711,606405,792035,638450,700973,528595,672478,426358,811890,509955,409125,217731,51947,195059,163931,697424,394099,786059,519896,993325,346915,649816,356374,7127,20871,660779,731202,164205,64547,71383,133367,80237,991465,982647,98633,850087,665124,714468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]