SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614118 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614118 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161538,723410,779387,218543,859442,229201,700375,1037501,14239,665785,421824,1005092,78592,858500,281244,773364,1010497,584324,340005,200962,511399,690312,406650,251075,791310,637234,462554,114613,769202,131632,588478,962691,630322,896227,55365,256675,230268,514315,853740,741686,306069,107556,678691,460645,164903,567649,179021,721694,33974,1020800,791847,326928,675070,159877,501982,814998,431014,737521,394190,920669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]