SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014034 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014034 [ RunTime:0.003598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804083,432150,846323,926509,569509,50283,948574,117752,738342,997153,802538,1041603,904088,939226,314892,146384,993017,508100,812484,701551,30660,1001658,883483,1027641,111413,55975,907674,641470,705342,448451,151290,86848,552350,853912,978492,393951,988867,632292,199991,115588,603485,440446,714603,473438,688894,524105,891589,944462,788009,305335,624114,872493,336116,237296,472374,796964,510950,705814,86636,646721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]