SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5143 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5143 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491034,1048585,116101,1010110,970275,677350,762968,932566,633345,777893,679028,914378,318074,261158,197321,414380,134571,99474,511904,721059,767268,807059,118792,341672,623447,694122,398020,837533,767158,855165,138772,496248,38804,261859,27882,881966,393538,423210,874436,915159,533138,5726,199067,139157,231567,436452,265003,730567,321333,523723,494842,976883,1004746,76880,765767,422843,958382,564175,312885,472321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]