SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423215 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423215 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298064,893456,62084,71427,704288,1012974,758312,342218,326445,459692,329136,937976,910049,332834,127397,667372,115255,130203,206195,1026381,155704,519071,267639,930378,176432,680550,418779,490462,463630,931913,558893,817412,194987,184964,1011172,328017,797315,393122,484437,657869,97366,25588,758823,104020,108714,731483,180730,671267,622500,657555,726797,652595,791365,813822,621836,684614,943789,206833,50054,523058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]