SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011169 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011169 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782316,850611,43834,775242,870930,851761,842677,91772,707421,326854,377727,1027168,312739,704284,393609,688727,363178,527292,743426,453581,836450,822367,511118,209525,392424,221264,281806,48712,688400,314025,23451,1036314,1045498,382798,373542,367293,648048,923873,912758,584993,445743,784370,243325,312813,986332,300779,619785,212894,184438,821728,860370,483205,362636,129648,678195,747405,878875,161713,235919,496932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]