SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514593 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514593 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65259,360467,771482,1032495,89705,633447,684219,332021,966835,504541,894086,931581,199145,463279,154641,1008189,761085,1028053,476286,27846,57904,554298,795470,387825,34964,230791,482541,233486,528254,737193,1000245,494428,601639,59076,111846,680434,33600,367473,293087,28078,1040691,834689,213025,1025181,725687,853653,540786,359051,275305,902471,977182,414216,634562,752440,226720,703501,406829,290573,92208,840464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003923s ]