SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404728 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404728 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503914,534293,140388,775069,951760,680351,12768,119070,894471,1012307,1007538,948127,649175,785537,595192,464309,825291,1036069,507064,636865,564541,690162,436079,640969,551527,463437,451302,967122,767630,101353,805535,698201,643459,519979,1007001,470484,182979,136392,791424,7828,582353,863857,376879,945748,355776,669366,199134,1034610,792816,1019718,655778,194787,878029,988640,275933,181461,724056,230674,33689,1016912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]