SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51964 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51964 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336077,115232,633880,431207,117372,155489,460513,897984,453561,625118,674500,244869,153491,717850,605370,660394,593181,761919,354849,833913,641715,562208,846745,226548,173755,376197,895796,973824,250208,667314,852449,786248,47377,214983,104264,330433,558978,442898,256657,773538,805751,5120,641192,680697,43884,758464,345080,952292,409017,707996,270528,247825,830286,515124,394209,227183,696238,889757,615820,515615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]