SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180101 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180101 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013225,589923,570972,983244,271991,647432,152091,22095,435813,47582,130911,586637,536358,880491,388772,7389,380389,647799,825782,843757,200224,979906,527390,410879,27491,856231,166903,533346,248147,616167,917619,411836,166299,994096,187589,998652,686896,659001,581725,19691,450992,38511,1042890,475567,343184,961052,907322,978395,890491,664020,232900,849012,580633,97921,830966,946602,592853,870972,940318,491156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]