SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004398 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004398 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46829,1030209,252362,815109,817188,81631,761359,5677,723570,906899,797433,855157,384235,98827,803074,254759,529186,688579,89915,508549,176119,319882,798327,526438,379238,892219,251688,195875,548299,877310,1038880,257118,590699,816902,387051,77430,918383,5674,325652,340155,268095,313921,509132,79451,917804,797713,296252,483705,364581,179817,334310,389116,231967,694846,373791,710236,427041,897328,936684,853617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]