SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453520 LIMIT 1 [ RunTime:0.000923s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453520 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495076,379699,301557,867149,323311,501859,72514,601201,566115,209881,866622,397516,517948,944470,420339,587779,99799,569364,71519,891439,976038,559080,644271,673777,400171,864622,370657,289862,832577,60330,702061,727132,258002,439839,100818,186173,517529,67816,604239,486168,905602,671306,139626,1019831,58358,164352,689265,641673,205284,872162,899204,825254,724587,285144,543084,819025,606831,588613,689148,201960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]