SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531246 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531246 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789556,791613,113295,400144,15894,132669,72144,894170,1042956,298820,220268,337594,982570,556096,683811,582099,1029277,122787,433,679567,1034980,422164,327293,1006791,788029,240208,877680,68676,298497,44346,557437,473921,955676,772943,565486,392079,242029,746421,890468,403097,920671,517546,748049,1013605,102473,97676,1043943,712533,14283,753688,534167,816325,993276,569646,50718,359077,348084,105877,915258,197590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]