SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504804 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504804 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12819,429674,706783,932501,1023018,969448,765722,401380,67930,606162,731708,890758,513827,704303,751953,713836,614316,275923,609023,571769,810492,1046065,323205,45594,537121,205681,66166,700976,845100,125045,335746,392207,961706,747908,195826,321554,946703,359258,240623,55310,491331,57864,29834,99323,425013,798159,185491,438995,281424,107684,710893,911325,953975,278451,103261,499921,192911,639650,564010,580248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]