SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538276 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538276 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021242,476684,703543,483465,318841,903375,218021,202135,930920,48398,558471,915662,337817,610116,354544,399452,525568,896862,239396,985162,409260,108954,368919,739831,520720,188400,89360,502772,166723,188461,379692,350798,1020890,196787,525303,488727,481784,481078,916632,877,942453,341662,391877,224199,222135,786936,166018,657282,151146,28010,417920,632138,1036440,938820,454736,1639,611939,584567,966680,934510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]