SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 951422 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 951422 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405563,517963,868540,684245,194464,486293,237730,879893,895598,795218,421775,423415,724458,143199,11181,79239,112097,195992,284836,444592,409103,288747,701745,418258,935649,945776,453508,783123,371762,457441,803937,107325,339903,506800,216273,262174,392880,174785,110252,597767,116681,1011606,1030350,413550,361932,371411,166904,386553,889488,623429,316416,1024319,37558,594431,541193,907380,447040,161683,928104,1028275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 951422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 951422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]