SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211780 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211780 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431041,568867,378962,162524,727821,922380,717963,435820,479559,266385,108400,725094,896324,937553,224706,484080,543322,53797,94999,1021076,941906,251082,235508,210610,397749,728422,275073,569103,442038,828702,908778,216165,1015305,639161,1012900,17232,907450,656761,695760,33969,446872,311793,405354,801738,221205,215082,819327,21120,121917,386590,389458,946992,850750,654521,715378,155806,807210,476497,869169,303761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]