SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022807 LIMIT 1 [ RunTime:0.004649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022807 [ RunTime:0.002891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556878,609684,966265,423153,744320,338677,528280,176684,992144,703358,150857,314733,220513,453689,512722,188436,59154,780812,460372,482410,482467,631060,773259,488174,74491,683720,366303,914411,897640,1011526,744764,877810,146590,100120,862760,467203,89142,63504,692226,56674,845459,769572,161376,439156,269498,548427,11108,879860,399709,711613,753078,311320,1005147,793392,248246,705364,379030,900826,407920,508086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000916s ]