SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 61210 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 61210 [ RunTime:0.003215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680895,49438,147401,560229,352050,588616,87092,325169,895450,957306,294464,1041581,798444,195699,287306,70379,950937,537029,630420,523562,3047,108279,249103,234137,1038048,537570,554825,462423,248161,97122,151814,510829,992787,56387,393254,918098,97547,47595,530869,94899,25029,662714,196100,855203,147887,590575,67456,815765,153129,862137,507722,912594,783851,492087,632739,796282,795797,438342,35403,440093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 61210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 61210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]