SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507875 LIMIT 1 [ RunTime:0.000965s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507875 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502424,947450,81706,584354,848794,907394,390696,114744,144086,787652,220645,678572,686068,839049,868931,140808,671205,223313,785870,482041,563548,597000,986010,413505,105274,140648,541210,200573,892260,252712,874965,238082,604174,407920,311588,470467,740455,173845,50570,824485,745561,338154,487284,438658,275726,1001254,988128,23095,643551,949186,675781,939168,313406,209377,680825,122771,339215,347413,914796,240501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004129s ]