SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406613 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406613 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968330,569943,86610,684697,677591,651187,74421,635383,1024240,646911,618021,526266,644994,626087,166705,398474,895630,1029062,666650,999306,531435,377955,385763,26977,531057,211914,174288,795777,410614,917520,437479,443801,129269,160047,808522,100057,746689,998972,404958,962321,311495,570647,761080,445409,795304,174668,562985,827343,8548,962910,290172,220696,61494,977659,700059,470362,4216,636485,137800,873267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]