SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003029s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645412 LIMIT 1 [ RunTime:0.003149s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645412 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300210,836115,374586,1034417,974037,323713,1040221,293090,719872,483930,978496,592977,859082,756981,959581,807220,201386,72594,565747,601694,246584,626505,692100,1018477,811283,472079,1030986,1028570,320581,868796,34331,307348,543030,649794,455451,723720,667370,578405,257341,675183,229330,254352,152127,321888,470041,358701,890031,351657,181675,34515,639803,953447,671561,587486,153411,221146,909432,657571,430712,755920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]