SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 371028 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 371028 [ RunTime:0.001361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949970,171320,891174,352753,1037093,557133,1022121,377727,941855,977317,333677,525792,70414,885269,343431,279176,6953,833927,247199,805524,799358,50134,12827,991093,892782,298000,364354,647220,385144,842801,32569,275542,611827,272726,1020742,365579,877832,350561,108038,450254,118182,888707,652769,940003,271081,516631,62590,1032345,414672,807613,1028553,590298,972460,815819,602990,616907,37309,292991,7447,252736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 371028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 371028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]