SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440354 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440354 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867691,1036173,743307,439477,304228,423992,2515,362154,207399,951108,74190,963775,202981,804000,464501,74437,1010740,544492,132056,723867,447255,971215,469551,515867,608820,808952,996579,845838,502439,498462,1003875,759739,470728,188390,688268,40633,801696,999536,582507,307040,404403,61984,790381,871068,976484,179945,337451,156729,440872,899064,72648,689587,174908,761873,1031402,846865,10807,366428,336108,849380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]