SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043300 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043300 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525199,128812,852754,39666,675246,495871,895046,1011457,666058,227527,775312,250630,297118,466534,815035,60060,826393,390320,425328,431840,948177,1020641,307594,29450,981569,436873,598554,506161,387455,134574,873652,233276,633961,888182,768965,252200,575203,312400,972852,866023,135637,687131,642353,214361,415288,222804,722698,872797,82718,169605,950707,161436,834646,477670,595429,252940,538913,560914,718614,725923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001476s ]