SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45396 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45396 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568934,779004,505466,296929,663376,494623,480813,472722,920272,842836,810012,929100,921798,348209,118744,854787,601057,481680,570183,233010,904449,732554,923661,789707,472107,507214,859392,393960,934283,284052,549162,743750,764771,2393,141923,8328,815289,588878,172266,393860,86767,977637,885525,180629,244052,344349,663523,657180,494735,419821,319660,474846,607202,930381,295155,538257,208007,727101,671486,153824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]