SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247014 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247014 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505050,648364,511856,2095,723286,1040677,31702,820452,242566,1038704,362266,976392,1047123,95001,807127,472449,120237,799712,543292,118248,179521,908643,904511,840039,781848,130073,102417,561955,198349,360909,431623,517134,573603,635333,313672,511191,965195,1018654,916978,113576,50560,708210,418928,309056,535310,742241,252789,882359,511130,748503,589531,654027,818777,834310,931776,196174,1014526,670845,17537,536079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]