SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406029 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406029 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499363,71679,894623,231567,1015935,1019690,496964,202347,198627,983871,376620,192929,730028,344440,484914,666700,164935,600052,1047326,324859,400783,703528,789556,472076,879266,289476,355011,741275,66538,405135,679849,436733,660914,926621,143807,274915,441065,819078,268934,265184,961199,809807,62091,684926,1043057,565512,530266,957454,32457,858127,310606,787730,1039243,551156,228168,431620,189468,354907,684130,1005355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]