SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103413 LIMIT 1 [ RunTime:0.001605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103413 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79270,324851,992299,242984,730489,776528,24680,397055,652633,30478,33265,545405,801804,475757,560684,278862,204420,619429,410537,779940,570248,205608,674014,554196,986523,893440,369543,443974,843020,484820,243373,806516,254731,730558,505946,11930,175814,130491,499816,577537,86227,115183,468457,669828,584817,289875,125468,554710,583610,1011570,948958,528080,898404,771100,173628,903986,50968,230219,804922,235699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]