SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009458 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009458 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522283,253578,598711,333879,43917,1048768,51369,31626,206784,990853,248949,599719,546075,701606,182198,336661,206138,4277,862870,775322,105042,406567,832149,183597,1000791,559953,40392,130907,723186,206026,918141,81586,47897,314995,413982,249941,6661,852794,183315,714493,25299,858148,840872,258054,239299,271447,999859,681941,647186,374016,687250,1015530,774107,406913,328946,984799,828013,135352,352107,645647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]