SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601218 LIMIT 1 [ RunTime:0.001277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601218 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440785,596278,254730,618327,563297,918736,199457,17654,385018,261126,356580,112662,589856,565658,68825,106806,46040,650407,628418,878397,625645,344672,969890,756602,1031841,227155,21487,692367,357572,489232,162846,599183,717230,139121,67789,595817,329950,191849,578914,355279,905879,494274,815465,810727,631295,343281,453855,626417,1024262,315839,928714,200862,344284,460718,431181,823857,523113,729578,237762,982249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]